If you have multiple Microsoft Excel versions on your system, or have toolbars you want to use on other systems or share with other users, you can merge those custom toolbars into the current version of Excel.
Your toolbar settings are stored in the following files and locations:
Excel Version | File Name | Location |
---|---|---|
Excel 2002 | Excel.xlb | C:\Documents and Settings\username\Application Data\Microsoft\Excel |
Excel 2000 | Excel.xlb | C:\Documents and Settings\username\Application Data\Microsoft\Excel |
Excel 97 | username8.xlb | Windows folder, unless your administrator specifies a different location |
Excel 95 | If user profiles are turned on, username.xlb; if user profiles are not turned on, Excel5.xlb | Windows folder |
Excel 5 | Excel5.xlb | Windows folder |
Excel 4 | Excel.xlb | Windows folder |
Set the security level to Medium or Low.